Example, test IF functions

Demonstrates nested IF statements with conditional SETs

Details

Rule Type
Time

Execution
Initialization

Parameters

Name	DataType	DefaultValue	Description
allowed_minutes	integer	0	Minutes past noon

Decision Tree

Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.

Line#	Level1	Level2	Level3	Comment
1	Start
2	IF(Punch Action = 1) →	↓
3		IF(Punch Time > ADD_TIME(NOW(), allowed_minutes)) →	↓
4			SET(Effective Punch Time = ADD_TIME(Punch Time, allowed_minutes))
5	↓		DONE
6		SET(Workgroup = 97)
7	SET(Division = 90)